﻿CREATE PROCEDURE [dbo].[proc_Order_Item_Getlist_OId]
	(
		@OId uniqueidentifier
	)
AS
	Select
		Id
		,OId
		,ProductId
		,ProductName
		,UnitPrice
		,Quantity
		,Salesman
		,SalesmanAccount
		,DepId
		,CompanyId
		,CreateDate
		,Occupancy
		,IsValid
		,DESCRIPTION
		,ProductCateName
	From Order_Item
	Where OId=@OId Order by ProductId,Id

